First:   truncate table ctdder

Then, working in small batches within a single year

Open the dts job ROVCtdDerLoader and set the connection1 property to point to the der file you want to load and then run it

Repeat as needed...

Then fix the target table below in two places: the year, and the platform id (989 is tibr, 988 is vnta)

INSERT INTO RovctdBinData_1997

  (DatetimeGMT,

        DeviceID,

        EpochSecs,

        LoadID_FK,

        bin,

        p,

        t,

        c,

        s,

        o2,

        light,

        oc,

        ot,

        trans,

        rlat,

        rlon,

        ptsFlag,

        o2Flag,

        lightFlag,

        latlonFlag,

        ProcessingID_FK)

       SELECT

        [dbo].EpochSecondsToDTG(usec) as DatetimeGMT,

        989,

        usec,

        -1997,

        usec,

        pres,

        [temp],

        cond,

        dbo.Salinity(cond,temp,pres),

        oxyg,

        light,

        o2curr,

        o2temp,

        transvolt,

        lat,

        lon,

        2,

        2,

        2,

        2,

        0

FROM         ctdder

go

---truncate table ctdder

---go